const { DataTypes } = require('sequelize')
const seq = require('../db/seq')

//创建数据库
const Goods = seq.define('koa_goods', {
    goods_name: {
        type: DataTypes.STRING,
        allowNull: false,
        comment: '商品名称'
    },
    goods_price: {
        type: DataTypes.DECIMAL(10, 2),
        allowNull: false,
        comment: '商品价格'
    },
    goods_num: {
        type: DataTypes.INTEGER,
        allowNull: false,
        comment: '商品库存'
    },
    goods_img: {
        type: DataTypes.STRING,
        allowNull: false,
        comment: '商品图片的url'
    },

},
    { paranoid: true }
)

//创建表
// Goods.sync({ force: true })

module.exports = Goods